Using Functions in a Range

In the use of statistical functions, recall that you can use multiple ranges at the same time.  Typically we use these functions when applied to a single, solid range, but there are exceptions.

To look at this, open the file Workers from your data files.

First, sort the table by regional responsibility.  To do this, simply click in the regions column (Column D) and select the A-Z sort.  

With any of the function we have discussed to this point, you may want to refer to multiple ranges.  To use one function in multiple ranges, do the following.

Skill Builder:  Using Functions With Multiple Ranges

1.	Click	In the Cell where you want your function value to 
		appear. 

2.	Type 	The function notation 
		=function(range1,range2)
		
		For instance, if you want to find the median value of 
		the two separate ranges, you would type 
		=median(E2:E11,E17:E25)

3.  	Hit	Enter.  The median number for these two ranges 
		will appear.

This same procedure can be used to find a value from multiple ranges with any of the statistical functions.  All of the information within the parenthesis will be used to calculate the final value.